package com.xiguaji.tiktok.v1.ins.brand.repository;

import com.xiguaji.tiktok.v1.ins.brand.model.InsStBrandGeneration;
import org.springframework.data.jdbc.repository.query.Query;
import org.springframework.data.repository.CrudRepository;

import java.util.List;

public interface InsStBrandGenerationRepository extends CrudRepository<InsStBrandGeneration,Integer> {


    @Query("select * from ins_st_brand_generation where bid = :bid order by generation_rank limit 0,:size")
    List<InsStBrandGeneration> findByBid(int bid,int size);
}
